2013-05-02 - 4674.1200 - Rel Notes - BI Reports Issues - Release 010 #BIReleases2013
Release Notes:
4674.1200 - BI Reports Issues - PNC200
Admin Info
Purpose
|
To fix the issues in BOBI 4.0 Production server
|
Release No
|
010
|
Submitted
|
05-02-2013
|
Submitted by
|
Praveen Guntuka
|
Source/Destination Systems
|
IT > BMS > Quality > Contracts to IT > BMS > Production > Contracts in SAP BOBI 4.0 Dev Environment
|
Release Sent To
|
Mark Harris
|
Object(s) Created By
|
Praveen Guntuka
|
Object(s) Tested By
|
Praveen Guntuka
|
Report Name
PNC200 - Receiving Compliance Invoiced Chargebacks
Name of Tables Used
SQL(neccgwebsql)
Customer
Material_Cost
NC_Category
NC_PO_Detail
NC_PR_Detail
NC_Ticket
NC_Type
Plant
Users
Vendors
NEC Crystal Reports Standards Check
1. PNC200 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. PNC200 NEC CR checklist has been sent to NEC and also attached here for reference:
PNC200 NEC CR Standard Check List.xlsx
Summary Level Check
Test Conducted
Group 1 : Vendors Number : 206177 - premium knits/ lanamex
SNo
|
Test Case
|
Value in Edge Report
|
Value in BOBI 4.0 Report
|
Pass/Fail
|
1
|
NCID / Vendor
|
0117646
|
0117646
|
Pass
|
2
|
NC Type
|
OVERAGE
|
OVERAGE
|
Pass
|
3
|
New Era PO
|
4500066440
|
4500066440
|
Pass
|
4
|
Charge
|
696.00
|
696.00
|
Pass
|
5
|
Delivered Date
|
01/09/2013
|
01/09/2013
|
Pass
|
Group 1 : Vendors Number : 206273 - Textile Manufacturers
SNo
|
Test Case
|
Value in Edge Report
|
Value in BOBI 4.0 Report
|
Pass/Fail
|
1
|
NCID / Vendor
|
0117518
|
0117518
|
Pass
|
2
|
NC Type
|
OVERAGE
|
OVERAGE
|
Pass
|
3
|
New Era PO
|
4500067107
|
4500067107
|
Pass
|
4
|
Charge
|
288.00
|
288.00
|
Pass
|
5
|
Delivered Date
|
01/03/2013
|
01/03/2013
|
Pass
|
Group 1 : Vendors Number : 207223 - MAX SUCCEED ENT LTD
SNo
|
Test Case
|
Value in Edge Report
|
Value in BOBI 4.0 Report
|
Pass/Fail
|
1
|
NCID / Vendor
|
0210460
|
0210460
|
Pass
|
2
|
NC Type
|
INCORRECT UPC LABELS
|
INCORRECT UPC LABELS
|
Pass
|
3
|
New Era PO
|
4500067411
|
4500067411
|
Pass
|
4
|
Charge
|
29.50
|
29.50
|
Pass
|
5
|
Delivered Date
|
01/02/2013
|
01/02/2013
|
Pass
|
Group 1 : Vendors Number : G35 - Ratone
SNo
|
Test Case
|
Value in Edge Report
|
Value in BOBI 4.0 Report
|
Pass/Fail
|
1
|
NCID / Vendor
|
0210505
|
0210505
|
Pass
|
2
|
NC Type
|
INCORRECT UPC LABELS
|
INCORRECT UPC LABELS
|
Pass
|
3
|
New Era PO
|
4500067937
|
4500067937
|
Pass
|
4
|
Charge
|
1498.00
|
1498.00
|
Pass
|
5
|
Delivered Date
|
01/18/2013
|
01/18/2013
|
Pass
|
Group 1 : Vendors Number : G40 - Everbright - Yihe
SNo
|
Test Case
|
Value in Edge Report
|
Value in BOBI 4.0 Report
|
Pass/Fail
|
1
|
NCID / Vendor
|
0325472
|
0325472
|
Pass
|
2
|
NC Type
|
INCORRECT PACKING
|
INCORRECT PACKING
|
Pass
|
3
|
New Era PO
|
4500066116
|
4500066116
|
Pass
|
4
|
Charge
|
55.00
|
55.00
|
Pass
|
5
|
Delivered Date
|
01/14/2013
|
01/14/2013
|
Pass
|
Group 1 : Vendors Number : G44 - Qianfeng (QF)
SNo
|
Test Case
|
Value in Edge Report
|
Value in BOBI 4.0 Report
|
Pass/Fail
|
1
|
NCID / Vendor
|
0325489
|
0325489
|
Pass
|
2
|
NC Type
|
INCORRECT PACKING
|
INCORRECT PACKING
|
Pass
|
3
|
New Era PO
|
4500066424
|
4500066424
|
Pass
|
4
|
Charge
|
113.00
|
113.00
|
Pass
|
5
|
Delivered Date
|
01/14/2013
|
01/14/2013
|
Pass
|
SNo
|
Test Case
|
Value in Edge Report
|
Value in BOBI 4.0 Report
|
Pass/Fail
|
1
|
NCID / Vendor
|
0117599
|
0117599
|
Pass
|
2
|
NC Type
|
Production Issue
|
Production Issue
|
Pass
|
3
|
New Era PO
|
4500066296
|
4500066296
|
Pass
|
4
|
Charge
|
2.00
|
2.00
|
Pass
|
5
|
Delivered Date
|
01/14/2013
|
01/14/2013
|
Pass
|
SNo
|
Test Case
|
Value in Edge Report
|
Value in BOBI 4.0 Report
|
Pass/Fail
|
1
|
NCID / Vendor
|
0116584
|
0116584
|
Pass
|
2
|
NC Type
|
OVERAGE
|
OVERAGE
|
Pass
|
3
|
New Era PO
|
4500070812
|
4500070812
|
Pass
|
4
|
Charge
|
33.00
|
33.00
|
Pass
|
5
|
Delivered Date
|
02/26/2013
|
02/26/2013
|
Pass
|
SNo
|
Test Case
|
Value in Edge Report
|
Value in BOBI 4.0 Report
|
Pass/Fail
|
1
|
NCID / Vendor
|
0210666
|
0210666
|
Pass
|
2
|
NC Type
|
INCORRECT UPC PACKING
|
INCORRECT UPC PACKING
|
Pass
|
3
|
New Era PO
|
4500070596
|
4500070596
|
Pass
|
4
|
Charge
|
90.50
|
90.50
|
Pass
|
5
|
Delivered Date
|
04/16/2013
|
04/16/2013
|
Pass
|
Group 1 : Vendors Number : Jiangyin - Jiangyin Dabutong Garment Factory
SNo
|
Test Case
|
Value in Edge Report
|
Value in BOBI 4.0 Report
|
Pass/Fail
|
1
|
NCID / Vendor
|
0117534
|
0117534
|
Pass
|
2
|
NC Type
|
OVERAGE
|
OVERAGE
|
Pass
|
3
|
New Era PO
|
4500065559
|
4500065559
|
Pass
|
4
|
Charge
|
302.00
|
302.00
|
Pass
|
5
|
Delivered Date
|
01/18/2013
|
01/18/2013
|
Pass
|
Group 1 : Vendors Number : Master Gar - Master Garments
SNo
|
Test Case
|
Value in Edge Report
|
Value in BOBI 4.0 Report
|
Pass/Fail
|
1
|
NCID / Vendor
|
0117598
|
0117598
|
Pass
|
2
|
NC Type
|
OVERAGE
|
OVERAGE
|
Pass
|
3
|
New Era PO
|
4500070746
|
4500070746
|
Pass
|
4
|
Charge
|
275.00
|
275.00
|
Pass
|
5
|
Delivered Date
|
01/18/2013
|
01/18/2013
|
Pass
|
Reference Document(Specification)
2013-04-18 - 4674.1200 - Spec - BI Reports Issues